SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspSiteEventType_UPDATE
(
@siteEventTypeId int = null,
@code int = null,
@name nvarchar(100) = null
)
AS

UPDATE
  [dbo].[SiteEventType]
SET
  [Code] = @code,
  [Name] = @name
WHERE
  [SiteEventTypeId] = @siteEventTypeId

GO
